package com.supermarket.api.entity;

import lombok.Data;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;
import java.util.Date;

/**
 * 用户信息表
 * @author 李其伟
 * @date 2023/10/29
 */
@Data
@Entity
@Table(name = "sm_user_info")
@org.hibernate.annotations.Table(appliesTo = "sm_user_info",comment="用户信息表")
public class UserInfoEntity extends BaseEntity{

    /**
     *  邮箱
     */
    @Column(name = "email",unique = true, columnDefinition = " varchar(128) comment '邮箱' ")
    private String email;
    /**
     * 邮箱验证
     */
    @Column(name = "email_verify", columnDefinition = "  bit(1) comment '邮箱验证' ")
    private Boolean emailVerify;
    /**
     *  手机号
     */
    @Column(name = "phone",unique = true, columnDefinition = " varchar(11) comment '手机号' ")
    private String phone;
    /**
     * 手机号验证
     */
    @Column(name = "phone_verify", columnDefinition = "  bit(1) comment '手机号验证' ")
    private Boolean phoneVerify;
    /**
     *  登陆名
     */
    @Column(name = "login_name",unique = true, columnDefinition = " varchar(100) comment '登陆名' ")
    private String loginName;
    /**
     *  密码
     */
    @Column(name = "password", columnDefinition = " varchar(64) comment '密码' ")
    private String password;
    /**
     *  用户名
     */
    @Column(name = "user_name", columnDefinition = " varchar(128) comment '用户名' ")
    private String userName;
    /**
     *  头像
     */
    @Column(name = "avatar", columnDefinition = " varchar(256) comment '头像' ")
    private String avatar;
    /**
     *  性别 0 未知  1 男性 2 女性
     */
    @Column(name = "sex", columnDefinition = " int(11) comment '性别 0:未知 1:男性 2:女性' ")
    private Integer sex;
    /**
     * 出生日期
     */
    @Column(name = "birthday", columnDefinition = " datetime comment '出生日期' ")
    private Date birthday;
    /**
     *  个性签名
     */
    @Column(name = "sign", columnDefinition = " varchar(256) comment '个性签名' ")
    private String sign;
    /**
     *  城市
     */
    @Column(name = "city", columnDefinition = " varchar(64) comment '城市' ")
    private String city;
    /**
     *  等级
     */
    @Column(name = "level", columnDefinition = " int(11) comment '等级' ")
    private Integer level;
    /**
     *  状态
     */
    @Column(name = "status", columnDefinition = " int(11) comment '状态' ")
    private Integer status;
    /**
     *  微信
     */
    @Column(name = "wx_id", columnDefinition = " varchar(64) comment '微信' ")
    private String wxId;
    /**
     *  QQ
     */
    @Column(name = "qq_id", columnDefinition = " varchar(64) comment 'QQ' ")
    private String qqId;
    /**
     *  微博
     */
    @Column(name = "wei_bo_id", columnDefinition = " varchar(64) comment '微博' ")
    private String weiBoId;
    /**
     * 创建时间
     */
    @Column(name = "create_time", columnDefinition = " datetime comment '创建时间' ")
    private Date createTime;
    /**
     * 修改时间
     */
    @Column(name = "update_time", columnDefinition = " datetime comment '修改时间' ")
    private Date updateTime;
}